<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html>
<head>
<title>SQLite C# tutorial</title>
<link rel="stylesheet" href="/cfg/format.css" type="text/css">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="keywords" content="C#, SQLite, ADO.NET, database, tutorial, learn SQLite C# ">
<meta name="description" content="This is SQLite C# tutorial. In this tutorial, you will learn the
    basics of programming SQLite with the C# language.">
<meta name="language" content="en">
<meta name="author" content="Jan Bodnar">
<meta name="distribution" content="global">

<script type="text/javascript" src="/lib/jquery.js"></script>
<script type="text/javascript" src="/lib/common.js"></script>

<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-5536206-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>

<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
  })();
</script>

</head>

<body>

<div class="container2">

<div id="wide_ad" class="ltow">

<div>
<script type="text/javascript"><!--
google_ad_client = "pub-9706709751191532";
/* 160x600, August 2011 */
google_ad_slot = "2484182563";
google_ad_width = 160;
google_ad_height = 600;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>

</div>


<div class="content2">

<a href="/" title="Home">Home</a>


<h1>SQLite C# tutorial</h1>


<p>
This is a C# tutorial for the SQLite database. It covers the basics of 
SQLite programming with C#. The examples were created and tested on Linux. 
</p>


<h2>Table of Contents</h2>

<ul>
    <li><a href="intro/">Introduction</a></li>
    <li><a href="read/">Reading data with SqliteDataReader</a></li>
    <li><a href="dataset/">DataSet</a></li>
    <li><a href="images/">Working with images</a></li>
    <li><a href="meta/">Getting database metadata</a></li>
    <li><a href="trans/">Transactions</a></li>
</ul>


<h2>SQLite &amp; C#</h2>

<p>
<b>SQLite</b> is an embedded relational database engine. 
It is a self-contained, serverless, zero-configuration and transactional SQL database engine. 
SQLite implements most of the SQL-92 standard for SQL. The SQLite engine is not a standalone process. 
Instead, it is statically or dynamically linked into the application. 
An SQLite database is a single ordinary disk file that can be located anywhere in 
the directory hierarchy.
</p>

<p>
<b>C#</b> is a modern, high-level, general-purpose, object-oriented programming language. 
It is the principal language of the .NET framework. The design goals of the 
language were software robustness, durability and programmer productivity.
It can be used to create console applications, GUI applications, 
web applications, both on PCs or embedded systems.
</p>


<h2>Similar tutorials</h2>

<p>
The <a href="/db/sqlite/">SQLite tutorial</a> covers the SQLite embedded
database engine. If you need to refresh your knowledge of the C# language, there is a full 
<a href="/lang/csharp/">C# tutorial</a> on ZetCode.  
The <a href="/db/sqlitevb/">SQLite Visual Basic tutorial</a>, 
<a href="/databases/sqlitephptutorial/">SQLite PHP tutorial</a> 
and <a href="/db/sqlitepythontutorial/">SQLite Python tutorial</a> provide programming
tutorials for the Visual Basic, PHP and Python language.
</p>

<div class="g-plusone"></div>


<div class="footer">
<div class="signature">
<a href="/">ZetCode</a> last modified April 18, 2012  <span class="copyright">&copy; 2007 - 2013 Jan Bodnar</span>
</div>
</div>

</div> <!-- content -->

</div> <!-- container -->

</body>
</html>

